package com.gzx.bi.modular.screen.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.gzx.bi.modular.screen.entity.GzxPredictAll;
import com.gzx.bi.modular.screen.vo.GzxPredictAllVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 线路mapper
 *
 * @author xbl
 */
public interface GzxPredictAllMapper extends BaseMapper<GzxPredictAll> {

    //获取当天的线路信息
    @Select({
            "<script>",
            "select caller,call_name as callName from gzx_predict_call " +
                    "where create_time like concat(#{currentMonth,jdbcType=VARCHAR},'%') " +
                    "</script>"
    })
    List<GzxPredictAllVo> getCallerInfo(String currentMonth);

}
